Restoring, Re-adding, or Purging Tables and Columns

You can restore, re-add, or purge tables and columns that are in an invalid state. You can either perform these actions individually while re-adding tables and columns or manage them in bulk through the Deleted Tables and Columns option.

Tables

To restore or re-add a table, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. On the Explore tab, click an environment tile to view its details and tables.
  3. Click Options.
    The available options appear.
  4. Click Add Table/Component.

    5. The Add Table Form page appears.

  5. In the Name box, enter the name of the invalid table.
  6. Click .

    7. A Confirm pop-up appears.

  7. Use the following options:

    • Delete and Add: Use this option to delete the invalid table and add a new one.

    • Restore: Use this option to restore the existing table.

To restore or purge the tables in bulk, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. On the Explore tab, click an environment tile to view its details and tables.
  3. Click Options.
    The available options appear.
  4. Click Deleted Tables and Columns.

    5. The Deleted Tables and Columns page appears.

  5. Under the Tables tab, select the required tables, and then use the following options:

    • Restore: Use this option to restore the selected tables.

    • Purge: Use this option to delete the selected tables from the database permanently .

Columns

To restore or re-add columns, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. On the Explore tab, click an environment tile to view its details and tables.
  3. In the Data Catalog pane, click a table to see its columns.
  4. Click Options.

    5. The available options appear.

  5. Click Add Column/Field.

    6. The Add Column Form page appears.

  6. In the Name box, enter the name of the invalid column.

  7. Click .

    A Confirm pop-up appears.

  8. Use the following options:

    • Delete and Add: Use this option to delete the invalid column and add a new one.

    • Restore: Use this option to restore the existing column.

To restore or purge the columns in bulk, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. On the Explore tab, click an environment tile to view its details and tables.
  3. Click Options.
    The available options appear.
  4. Click Deleted Tables and Columns.

    5. The Deleted Tables and Columns page appears.

  5. Click the Columns tab.
  6. Select the required columns, and use the following options:

    • Restore: Use this option to restore the selected columns.

    • Purge: Use this option to delete the selected columns from the database permanently.